CREATE PROCEDURE [dbo].[authors_select_by_id]
    @authorId int
AS 
SELECT
    [AuthorId],
    [LastName],
    [FirstName],
    [MiddleName]
FROM [dbo].[Authors] 
WHERE
    Authors.[AuthorId]=@authorId
RETURN 0
